Optimization - Material list

Edited materials

• Clicking the Edited materials button will list the square meter materials and colors that make up the furniture in the room.
  
  
  • Selecting these will list the elements made from them in the table below.
    
    
  • The element list can be freely edited, data can be rewritten, rows can be deleted, and new ones can be added. The list can consist entirely of manually entered rows, independent of the visual plan.
    
    
  • Each element in the list receives a continuous identifier number. Even identical elements are listed in separate rows.
    
    
  • The content of this list will be optimized.

• The list separately indicates the cut size and the finished size, naturally in both grain direction and cross direction.
  
  
  • The cut size shows exactly how big the element needs to be cut.
    
    
  • The finished size indicates how large it will be after edge banding, pre-milling, and other edge machining. The finished size columns only appear if the sizes differ from the cutting sizes.

Deleting the list

• The first icon can delete the entire table, and the second icon can delete the selected row.
  
  

Setting rotatable

• The middle three icons set the rotatability of the sheets.
  
  
  • The first makes all sheets rotatable.
    
    
  • The second deletes all rotatabilities.
    
    
  • The third icon changes the rotatability of the selected sheet. An X in the list indicates if the sheet is rotatable. This is shown in yellow on the drawing. The two icons on the right swap the dimensions of the sheets in the grain and cross directions, either all at once or individually. Naturally, the edge banding indications follow this.
    
    
  • If an element is rotatable, the program decides whether to rotate it or not. If we swap its dimensions, it will definitely be rotated.
    
    
  • If automatically rotatable is turned on, elements that can be rotated even in grain direction materials (e.g., connectors) will automatically appear as rotatable. These must be specified in advance on the basic elements editing page.
    
    

Setting basic element rotatability

• Select the desired basic element, then enter "x!" in the printing note and modify it to make the element rotatable. Anything can be entered afterward, but the "x!" will not appear when the note is displayed.
  
  

Adding a new row to the list

• At least three pieces of information are needed for a new row: Grain size, Across size, and quantity. These are added to the table by pressing the New row button. Additional data, such as edge banding, name, etc., can also be provided.
  
  
• For faster input, the cursor automatically jumps to the next field with the Enter key. In the third field (quantity), pressing Enter immediately adds the new row to the table, and the cursor jumps back to the first field. Normally, the value of the field where the cursor jumps is cleared, but by holding the Control key, it remains, so the same data does not need to be re-entered for repetitive entries.
  
  
• The entered dimensions are the finished sizes! The cutting size dynamically changes with the adjustment of the size-modifying values (edge band thickness, pre-milling, allowance)!
  
  
• Using the arrow icon under the job identifier field, the entered text is added to all rows in the list.
  
  

Saved lists

Clicking the saved lists button displays the names of the already saved element lists.

• The list includes the names of the saved element lists, their materials, and the time they were saved, sorted chronologically.
  
  
•   The sorting can be changed from chronological to alphabetical order.
  
  
• The search fields can be used to narrow the list by entering characters to search for specific texts. The * (wildcard) character can be used as usual, but it is not necessary to include it at the end of the condition. For example, "a" will display only rows starting with the letter "a". "*2" will display rows containing the number 2 anywhere. The first field searches by name, and the second by colours.
  
  
• Saved lists can be applied individually or combined.
  
  
• Clicking the Load list button inserts its content into the element list, replacing the previously existing ones.
  
  
• The Add to list button, on the other hand, retains the existing rows and continues with the saved list. This allows you to optimize elements of several rooms with the same material simultaneously.
  
  

Saving the list

• After filling in the Description and Material-colour fields, the list can be saved by pressing the Save new list button.
  
  
• The customer's name, address, and Note are also saved. However, an empty element list cannot be saved!
  
  
• The Modify button allows you to change the data of the selected and read element list.
  
  
• When saving, the finished sizes are saved!
  
  
• After reloading, the cutting size can change with the adjustment of the size-modifying values (edge band thickness, pre-milling, allowance)!
  
  
• These saves are made in the database, but it is also possible to save the data to a file. This is necessary if you want to transfer element lists from one computer to another, where Piper is also used.
  
  

  Reading, adding, saving to file.

  The icon allows you to import material lists from an Excel file.

  Export options to .xlsx or .csv file.

Keywords: #material list #optimization #arranged materials #rotatability #saving list