This utility groups rolls of raw materials into sets of finished goods based on a user-supplied inventory report and user selections. Rolls are assigned to sets up to the configured set weight limit and additional sets are created up to the specified order weight. The algorithm attempts to balance both FIFO and set weight targets in its assignment choices.
Download and run the latest release.
Note: This app stores data in a database.db3 file located in the user's home directory.
- Click "Browse", navigate to, and select the latest Inventory Report that you would like to build orders from
- Select the Product from the dropdown in "Product Selection"
- Enter the weight in lbs in the "Weight (lbs)" field
- Select the Material in the "Material" dropdown to adjust what Material will be used to build the specified Product
- Click "Generate sets" and wait for the utility to run.
- The output of the utility will be added to a new sheet in the selected Inventory Report
Note: The inventory report cannot be open during set generation.
- Fill in the fields at the bottom of the "Setup" tab
- Click "Save" and verify that a new line was added to the product list window
- Highlight the product configuration to be deleted
- Click "Delete" in the top-right corner of the window
- Warning: Deletion occurs immediately and you will not be prompted to confirm the deletion. Undoing deleted configurations is not supported at this time.
- Highlight the product configuration to be edited
- Click "Edit" in the top-right corner of the window, the values will be populated into the entry fields at the bottom of the window
- Make any desired edits
- Click "Save" and verify that edits are updated in the product list window
Please submit issues here or email the author directly.