In this example we will show you how to paste the box data from a spreadsheet or a text file in which the data is delimited by tabs into the input window.
Go to the spreadsheet (such as Excel) or from any text file that contains columns separated by tabs and copy the data. The order of the columns is the following:
- Unit (write 0 for mm/kg, 1 for cm/kg or 2 for inches/pounds).
- Type (fill this column with the value 1 assigned to boxes).
- Color (hexadecimal).
- Code (optional).
- Description (optional)
Open a new document window starting from box on File
> New Data Sheet
> Start from Box
. Paste the data in the input window using the appropriate option on the Edit
: if you want Ti-Hi
pallets it is not necessary to set the Amount
of boxes because QPM will fill the pallets until the pallet constraints are met, therefore enter zero as amount.
In this exercise we want to calculate mixed boxes in pallet loads, therefore go to Tools
> Calculate Multiple Boxes
After calculating, you will see the Available Solutions
window with the list of pallets for the box amounts you set before.