Template excel file
You have an opportunity to upload list of loads. Just download the template excel file and fill them according to tutorial below.
Tutorial
There is the ability to load multiple loads on our platform. To do this, first download our Template.xlsm. On our loadboard, shippers have the option of fast and easy uploading of their bulk load list through an excel file.
1. Download the template excel file and fill them according to in the tutorial below.
And enter the data about your cargo in the Excel file according to the Tutorial for filling below.
Next, upload the completed Excel file to the Worder platform
At the end of the download, you will see a table with successfully loaded cargo.
Be sure to check the correctness of the data in the original table of loaded goods. If the data was loaded incorrectly, delete this load or reload the Excel file again.
After checking the data, click the button below “ADD” and the entire list of cargoes will be brought to your account and ready for the match.
If the data on some cargoes were filled in incorrectly, then this cargo will not be entered into the table. You will see the total number of not loaded goods in the Total denied column
And more detailed information about errors can be viewed in the window by clicking on the "Denied loads" button
To start working with Excel loading, the system will ask you to enable support for "macros" . This is an internal Excel tool, with which we made the template more functional and understandable to use for users of our platform.
The document describes many fields, on hovering over which a tooltip pops up. These are the fields that you need to pay attention to in order to correctly fill out and then upload a document to our platform
Optional fields are colored differently. They can be left blank as unnecessary.
Mandatory are additionally marked with an asterisk. In order for the loading of the cargo to be successful and the platform can correctly select a courier for it, the required fields must be filled
Separately, we note the points that are important when filling out an Excel document on the Worder platform:
Drop-down lists have also been processed in the document, with the help of which the user can select the value that suits him
General Info
Load name - specify the name of the shipment. Limit of 30 characters
Load NR - specify a unique cargo number. Limit of 30 characters
Equipment type - several Equipment type can be selected
Equipment type codes:
Code
Definition
Code
Definition
Code
Definition
Code
V2
Definition
Van Double
Code
DD
Definition
Double Drop
Code
IR
Definition
Insulated Van or Reeder
Code
VH
Definition
Van Hotshot
Code
LA
Definition
Drop Deck Landoll
Code
LB
Definition
Lowboy
Code
VI
Definition
Van Insulated
Code
DT
Definition
Dump Trailer
Code
LR
Definition
Lowboy or RGN
Code
OT
Definition
Van Open-Top
Code
F
Definition
Flatbed
Code
LO
Definition
Lowboy, Over Dimension
Code
VC
Definition
Van w/Curtains
Code
FA
Definition
Flatbed Air-Ride
Code
MV
Definition
Moving Van
Code
VW
Definition
Van, w/Blanket Wrap
Code
FN
Definition
Flatbed Conestoga
Code
NU
Definition
Pneumatic
Code
VP
Definition
Van, w/Pallet Exchange
Code
F2
Definition
Flatbed Double
Code
PO
Definition
Power Only
Code
VV
Definition
Van Vented
Code
FO
Definition
Flatbed, Over Dimension
Code
RV
Definition
Reefer or Vented Van
Code
VM
Definition
Van w/Team
Code
F2
Definition
Flatbed Double
Code
RM
Definition
Reefer w/Team
Code
V
Definition
Van
Code
FO
Definition
Flatbed, Over Dimension
Code
RP
Definition
Reefer, w/Pallet Exchange
Code
VZ
Definition
Van HazMat
Code
FC
Definition
Flatbed,w/Chains
Code
R
Definition
Reefer
Code
VN
Definition
Van Intermodal
Code
FR
Definition
Flatbed/Van/Reefer
Code
RG
Definition
Removable Gooseneck
Code
VG
Definition
Van Lift-Gate
Code
FD
Definition
Flatbed or Step Deck
Code
RZ
Definition
Reefer HazMat
Code
VT
Definition
Van or Flatbed
Code
FS
Definition
Flatbed w/Sides
Code
TA
Definition
Tanker Aluminium
Code
VR
Definition
Van or Reefer
Code
FT
Definition
Flatbed w/Tarps
Code
SB
Definition
Straight Box Truck
Code
CN
Definition
Conestoga
Code
FM
Definition
Flatbed w/Team
Code
SD
Definition
Step Deck
Code
CI
Definition
Container Insulated
Code
FZ
Definition
Flatbed HazMat
Code
SR
Definition
Step Deck or RGN
Code
CR
Definition
Container Refrigerated
Code
FH
Definition
Flatbed Hotshot
Code
SN
Definition
Stepdeck Conestoga
Code
CV
Definition
Conveyor
Code
HB
Definition
Hopper Bottom
Code
ST
Definition
Stretch Trailer
Full/Partial - if the load implies full load, choose F (Full); if partial - P (Partial)
Equipment length - indicate the length of the cargo in feets
Load weight - indicate the weight of the load in lbs
Handling unit - be sure to select the type of cargo from the proposed list (boxes, pallets, drums, totes, gaylords, crates, floor loaded)
Quantity type - be sure to indicate the number of units
Approval type - be sure to select auto / manual from the suggested list
Select "Auto" approval type if you want it to be confirmed automatically when a carrier books your load
Date / Time
Pick up Date / Time
In columns J-N we indicate the time and place where you need to pick up the cargo.
City, State, Country, Address
For the search and matching systems to work correctly, it is advisable to fill in the cities as shown in the tooltip зке: City, State, Country
Delivery Type
Date
Dates must be filled in the following format: mm/dd/yyyy
To choose the time of loading and unloading your cargo that suits you, there is a special column in the document, with which you can choose the type that suits you - “FCFS” (“First come - first serve”) or “PPA” ( “Need appointment”). When choosing “FCFS”, you need to specify the time FROM and TO convenient for you. When choosing “PPA”, the shipper is required to fill one column with the time at which he is ready to accept the track to load his load. Time "TO" is automatically filled in with a dash.
Delivery Date / Time
Pay attention to the Delivery state column for correct operation of search and matching systems, it is desirable to fill in exactly this way. The rest of the fields are filled in the same way with pick up date/time information
Logistic details
Information about the contact person. First name, Last name, Phone, Email fields are required.
Other details
In this field you can add a comment to the order.
Payment details
Price - indicate the price you are willing to pay for the ride. The price per mile will be automatically calculated according to the pick up city - delivery city route and the price you specified.
Receive bid option - The carrier will be able to place a bid and set his offer for the load Select "true" if you want to enable the bidding option. Select "false" if you opt out of betting
Upload excel file
Upload excel file with your list of loads.