{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","LTL Request","TL Request","Sheet1","Codes"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Initial Setup (Must only be done once!)"]
["• Please save a copy of this file to your desktop - this will ensure macros are enabled. "]
["• Once the file is saved, close it and reopen your newly saved copy."]
["• Please turn off the AutoSave feature. This feature is located on the top left of the spreadsheet."]
["• Turning off AutoSave will allow the file to open in its original state each time, preventing the removal of previous order data."]
["• If you do not have Outlook as your default email application setup, please follow the steps outlined below for Microsoft or Apple based systems:"]
["Link to Microsoft Support page here"]
["Link to Mac Support page here"]
[]
["Submitting an order"]
["•If shipment is under 8000lbs or less than 749 cubic feet use the LTL Request Form"]
["•If shipment is over 8000lbs or greater than 749 cubic feet use the TL Request Form"]
["• Each shipment will require an individual form to be submitted"]
["• Should you require an additional commodity, click the \"Add Commodity\" button and it will generate additional items for you to fill out. Please ensure that all information entered is accurate and complete before proceeding."]
["• After completing the form, click the \"SUBMIT ORDER\" button."]
["• This action will use your default Outlook email application to generate the automatic order submission email. "]
["• The email will be directed to C H Robinson for processing. Please note that this email is pre-formatted and should not be edited in any way."]
[]
[]
[]
["Any questions or concerns, please reach out to chr-neiman@chrobinson.com for assistance. "]

{"sheet":"LTL Request","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[12,8,17,10],[19,3,19,4],[40,3,40,4],[33,3,33,4],[0,3,0,4],[2,3,2,4],[2,6,2,7],[1,3,1,4]]}
[null,null,null,"CHR LTL ORDER TENDER FORM",null,null,null,null,null,null,null,null,null,"1:00"]
[null,null,null,"For Shipments under 8000 lbs or less than 749 cubic feet use the LTL Request Form",null,null,null,null,null,null,null,null,null,"1:15"]
[null,null,null,"Pickup Information",null,null,null,null,null,null,null,null,null,"1:30"]
[null,null,null,"CHR Customer/Bill To *","Neiman Marcus - C8828016",null,null,null,null,null,null,null,null,"1:45"]
[null,null,null,"Customer Primary Ref # (PO) *",null,null,null,null,null,null,null,null,null,"2:00"]
[null,null,null,"Material Type *"]
[null,null,null,"Shippers Company Name *",null,null,null,null,null,null,null,null,null,"2:15"]
[null,null,null,"Contact Name *",null,null,null,null,null,null,null,null,null,"2:30"]
[null,null,null,"Contact Phone #  *",null,null,null,null,null,null,null,null,null,"2:45"]
[null,null,null,"Address *",null,null,null,null,null,null,null,null,null,"3:00"]
[null,null,null,"City *",null,null,null,null,null,null,null,null,null,"3:15"]
[null,null,null,"State *",null,null,null,null,null,null,null,null,null,"3:30"]
[null,null,null,"Zip *",null,null,null,null,null,null,null,null,null,"3:45"]
[null,null,null,"Email address  *",null,null,null,null,null,null,null,null,null,"4:00"]
[null,null,null,"Pick Up Reference Number *",null,null,null,null,null,null,null,null,null,"4:15"]
[null,null,null,"Pickup Date *",null,null,null,null,null,null,null,null,null,"4:30"]
[null,null,null,"Ready Time *",null,"AM",null,null,null,null,null,null,null,"4:45"]
[null,null,null,"Close Time *",null,"PM",null,null,null,null,null,null,null,"5:00"]
[null,null,null,"Shipper's Special Instructions",null,null,null,null,null,null,null,null,null,"5:15"]
[null,null,null,"Delivery Information",null,null,null,null,null,null,null,null,null,"5:30"]
[null,null,null,"DC *",""]
[null,null,null,"Consignee Name *",null,null,null,null,null,null,null,null,null,"5:45"]
[null,null,null,"Contact Name  *",null,null,null,null,null,null,null,null,null,"6:00"]
[null,null,null,"Contact Phone #  *",null,null,null,null,null,null,null,null,null,"6:15"]
[null,null,null,"Address *",null,null,null,null,null,null,null,null,null,"6:30"]
[null,null,null,"City *",null,null,null,null,null,null,null,null,null,"6:45"]
[null,null,null,"State *",null,null,null,null,null,null,null,null,null,"7:00"]
[null,null,null,"Zip *",null,null,null,null,null,null,null,null,null,"7:15"]
[null,null,null,"Delivery Reference Number *",null,null,null,null,null,null,null,null,null,"7:30"]
[null,null,null,"Due Date *",null,null,null,null,null,null,null,null,null,"7:45"]
[null,null,null,"Open Time",null,"AM",null,null,null,null,null,null,null,"8:00"]
[null,null,null,"Close Time",null,"PM",null,null,null,null,null,null,null,"8:15"]
[null,null,null,"Delivery Special Instructions",null,null,null,null,null,null,null,null,null,"8:30"]
[null,null,null,"Special Requirements"]
[null,null,null,"Liftgate","No"]
[null,null,null,"Inside Delivery","No"]
[null,null,null,"Limited Access","No"]
[null,null,null,"Residential","No"]
[null,null,null,"Construction Site","No"]
[null,null,null,"Delivery Appointment","No"]
[null,null,null,"Commodity Information",null,null,null,null,null,null,null,null,null,"8:45"]
[null,null,null,"Product Name *",null,null,null,null,null,null,null,null,null,"9:00"]
[null,null,null,"Class *",null,null,null,null,null,null,null,null,null,"9:15"]
[null,null,null,"NMFC Code *",null,null,null,null,null,null,null,null,null,"9:30"]
[null,null,null,"Total Weight *",null,null,null,null,null,null,null,null,null,"9:45"]
[null,null,null,"Quantity *",null,null,null,null,null,null,null,null,null,"10:00"]
[null,null,null,"Packaging Type *","CTN",null,null,null,null,null,null,null,null,"10:15"]
[null,null,null,"Total Pallets *",null,null,null,null,null,null,null,null,null,"10:30"]
[null,null,null,"Dims (L x W x H) *",null,null,null,null,null,null,null,null,null,"10:45"]
[null,null,null,"Cargo Value (Cost Value)",null,null,null,null,null,null,null,null,null,"11:00"]
[null,null,null,"Commodity PO *",null,null,null,null,null,null,null,null,null,"11:15"]
[null,null,null,"Handling *","Non Stackable",null,null,null,null,null,null,null,null,"11:30"]
[null,null,null,"Temperature Requirement","No"]
[null,null,null,"Temperature Range"]

{"sheet":"TL Request","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,6,2,7],[12,8,17,10],[19,3,19,4],[33,3,33,4],[0,3,0,4],[2,3,2,4],[1,3,1,4]]}
[null,null,null,"CHR TL ORDER TENDER FORM",null,null,null,null,null,null,null,null,null,"1:00"]
[null,null,null,"For Shipments over 8000 lbs or greater than 749 cubic feet use the LTL Request Form",null,null,null,null,null,null,null,null,null,"1:15"]
[null,null,null,"Pickup Information",null,null,null,null,null,null,null,null,null,"1:30"]
[null,null,null,"CHR Customer/Bill To *","Neiman Marcus - C34088",null,null,null,null,null,null,null,null,"1:45"]
[null,null,null,"Customer Primary Ref # (PO) *",null,null,null,null,null,null,null,null,null,"2:00"]
[null,null,null,"Material Type *"]
[null,null,null,"Shippers Company Name *",null,null,null,null,null,null,null,null,null,"2:15"]
[null,null,null,"Contact Name *",null,null,null,null,null,null,null,null,null,"2:30"]
[null,null,null,"Contact Phone #  *",null,null,null,null,null,null,null,null,null,"2:45"]
[null,null,null,"Address *",null,null,null,null,null,null,null,null,null,"3:00"]
[null,null,null,"City *",null,null,null,null,null,null,null,null,null,"3:15"]
[null,null,null,"State *",null,null,null,null,null,null,null,null,null,"3:30"]
[null,null,null,"Zip *",null,null,null,null,null,null,null,null,null,"3:45"]
[null,null,null,"Email address  *",null,null,null,null,null,null,null,null,null,"4:00"]
[null,null,null,"Pick Up Reference Number *",null,null,null,null,null,null,null,null,null,"4:15"]
[null,null,null,"Pickup Date *",null,null,null,null,null,null,null,null,null,"4:30"]
[null,null,null,"Ready Time *",null,"AM",null,null,null,null,null,null,null,"4:45"]
[null,null,null,"Close Time *",null,"PM",null,null,null,null,null,null,null,"5:00"]
[null,null,null,"Shipper's Special Instructions",null,null,null,null,null,null,null,null,null,"5:15"]
[null,null,null,"Delivery Information",null,null,null,null,null,null,null,null,null,"5:30"]
[null,null,null,"DC *",""]
[null,null,null,"Consignee Name *",null,null,null,null,null,null,null,null,null,"5:45"]
[null,null,null,"Contact Name  *",null,null,null,null,null,null,null,null,null,"6:00"]
[null,null,null,"Contact Phone #  *",null,null,null,null,null,null,null,null,null,"6:15"]
[null,null,null,"Address *",null,null,null,null,null,null,null,null,null,"6:30"]
[null,null,null,"City *",null,null,null,null,null,null,null,null,null,"6:45"]
[null,null,null,"State *",null,null,null,null,null,null,null,null,null,"7:00"]
[null,null,null,"Zip *",null,null,null,null,null,null,null,null,null,"7:15"]
[null,null,null,"Delivery Reference Number *",null,null,null,null,null,null,null,null,null,"7:30"]
[null,null,null,"Due Date *",null,null,null,null,null,null,null,null,null,"7:45"]
[null,null,null,"Open Time",null,"AM",null,null,null,null,null,null,null,"8:00"]
[null,null,null,"Close Time",null,"PM",null,null,null,null,null,null,null,"8:15"]
[null,null,null,"Delivery Special Instructions",null,null,null,null,null,null,null,null,null,"8:30"]
[null,null,null,"Commodity Information",null,null,null,null,null,null,null,null,null,"8:45"]
[null,null,null,"Product Name *",null,null,null,null,null,null,null,null,null,"9:00"]
[null,null,null,"Total Weight *",null,null,null,null,null,null,null,null,null,"9:45"]
[null,null,null,"Quantity *",null,null,null,null,null,null,null,null,null,"10:00"]
[null,null,null,"Packaging Type *","CTN",null,null,null,null,null,null,null,null,"10:15"]
[null,null,null,"Total Pallets *",null,null,null,null,null,null,null,null,null,"10:30"]
[null,null,null,"Dims (L x W x H) *",null,null,null,null,null,null,null,null,null,"10:45"]
[null,null,null,"Cargo Value (Cost Value)",null,null,null,null,null,null,null,null,null,"11:00"]
[null,null,null,"Commodity PO *",null,null,null,null,null,null,null,null,null,"11:15"]
[null,null,null,"Handling *","Non Stackable",null,null,null,null,null,null,null,null,"11:30"]
[null,null,null,"Temperature Requirement","No"]
[null,null,null,"Temperature Range"]

{"sheet":"Sheet1","index":3,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[null,"T104494"]
[null,"T11966"]
[null,"T191358"]
[null,"T1934631"]
[null,"T203472"]
[null,"T218939"]
[null,"T272522"]
[null,"T46034"]
[null,"T8154"]
[null,"T9131"]
[null,"T3699666"]
[null,"T9715"]
[null,"T129576"]
[null,"T264"]
[null,"T2080614"]
[null,"T4246"]
[null,"T1176"]
[null,"T5324994"]
[null,"T95332"]
[null,"T102231"]
[null,"T2197553"]
[null,"T2295160"]

{"sheet":"Codes","index":4,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["PLT",null,"Yes",null,"No","No","Non Stackable",null,"Merchandise",null,null,"WCODE",null,null,null,null,null,null,null,"LTL"]
["PCS",null,"No",null,"Yes: PICKUP","Yes","Stackable",null,"Supplies",null,"NMD-WHS-7090","W1271975","Neiman Marcus Direct - Sun Logistics NMD-WHS-7090","115 Morrison Ave","Thomasville","NC",27360,"Receiving","336-687-0416","VLOOKUP DC","VLOOKUP Name","VLOOKUP Address","VLOOKUP City","VLOOKUP State","VLOOKUP Zip","VLOOKUP Contact Name","VLOOKUP Contact Phone"]
["BAG",null,null,null,"Yes: DROP",null,null,null,"Equipment",null,"PNDC-7010 ","W77566031","PINNACLE POINT DISTRIBUTION CENTER PNDC 7010","4123 Pinnacle Point Drive","Dallas","TX",75211,"Receiving","214-331-9620",{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:K,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:N,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:O,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:P,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:Q,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:R,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:R,8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('LTL Request'!E21,Codes!K:S,9,FALSE),\"\")","v":""}]
["BOX",null,null,null,null,null,null,null,"Other",null,"BUNZL-Dallas ","W1209720","INTEPLAST GROUP","101 INTEPLAST GROUP","Lolita","TX",77971,"Receiving","847-406-6522"]
["CTN",null,null,null,null,null,null,null,null,null,"WCSC-7077 ","W75816256","West Coast Service Center 7077 - WCSC","2500 S WORKMAN MILL","Whittier","CA",90601,"Receiving","562-463-9333","TL"]
["DRM",null,null,null,null,null,null,null,null,null,"WBUZNL-New Jersey ","W1127137","Bunzl New Jersey","27 Distribution Way","Monmouth Junction","NJ","  08852","Receiving","732-821-7000","VLOOKUP DC","VLOOKUP Name","VLOOKUP Address","VLOOKUP City","VLOOKUP State","VLOOKUP Zip","VLOOKUP Contact Name","VLOOKUP Contact Phone"]
[null,null,null,null,null,null,null,null,null,null,"The Gilbert Company","W7388321","The Gilbert Company","1000 Riverside Dr. Dock # 8 ","Keasbey","NJ","  08852","Receiving","800-229-0703",{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:K,1,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:N,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:O,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:P,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:Q,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:R,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:R,8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP('TL Request'!E21,Codes!K:S,9,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Performance Team - West","W1277164","Performance Team - West","12816 Shoemaker Avenue","Santa Fe Springs","CA",90670,"Receiving","562-741-1300"]
[null,null,null,null,null,null,null,null,null,null,"ECDC-7060 ","W78288104","East Coast Distribution Center - 7060 - ECDC","600 RESEARCH DRIVE","Pittston","PA",18640,"Receiving","570-883-2410"]
[null,null,null,null,null,null,null,null,null,null,"NMD-WHS-7089","W3306499","Neiman Marcus Direct - Pinnacle NMD-WHS-7089","4123 Pinnacle Point Drive","Dallas","TX",75211,"Receiving","214-331-9620"]
[null,null,null,null,null,null,null,null,null,null,"Bunzl Distribution","W11908163","Bunzl Distribution","2005 Valley View Ln.","Dallas","TX",75234,"Receiving","972-241-3800"]