|
Pasting Box Data for Pallet Calculations
| In one of the container load examples, we paste the box data from a spreadsheet or a text file in which the data is delimited by tabs. This now can also be done through the Start From Box dimensions window. |
| The first step is to open a new document window starting from box dimensions and set the units appropriately. |
 |
| Then, we go to the spreadsheet or text file that contains the tab-delimited data. It is important for this data to contain the following columns: Unit, Type, Length, Width, Height, Weight, Color, Amount, Code (optional) and Description. The unit value can be equal to 0 (mm/kg), 1 (cm/kg) or 2 (inches/lbs). The type is always equal to 1. The color format is similar to HTML color formatting (#RRGGBB), where the Red (RR), Green (GG) and Blue (BB) values are Hexadecimal values. The rest of the dimensions are entered using the appropriate unit. QPM will translate the dimensions if the copied units are different from the units in the input window. Please note that if the input window uses "commas" for separating decimals, |
 |
| The next step is to copy and paste the data onto the input window. QPM will translate the dimensions if the copied units are different from the units in the input window. Please note that if the input window uses commas (",") for separating decimals, the pasted data will too need to use commas. Select the pallet type and other constraints as necessary. |
 |
| In this case, we used the "Calculate Multiple Boxes" feature from the Tools menu to obtain the mixed boxes and pallets. |
 |
|
