11/3/2023 0 Comments Excel plywood cut optimizerThe actual Excel sheet can be downloaded fromĪlgorithm for calculating a highly efficient cutting layout forcuttingplanks with shearing/panel saws, etc. In this case, the yield is higher when the part is oriented vertically. If we change the orientation of the member (swap the horizontal andvertical),we get How many 400*300 pieces can be obtained from an 1800*900mm originalplate? If this is 2-dimensional and all the members are the same "Int" is here assumed to be a function that truncates after the decimalpoint,such as in Excel. To simplify the story, let's first consider a 1D member of the same size.Īssuming the width of the saw is 3mm, how many 200mm can be takenfrom1800mm? However, this can be calculated with Excel. How many pieces of the same size can be taken from one original plate? It isnotpossible to calculate the plate count using only functions. There are macros available, so it is not theoretically impossible.However,dedicated software should be developed for the calculation volume. Because of the combinatorial optimizationproblem,a dedicated application is required. As it turns out, Excel is not suitable forplatecutting calculations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |