JYT Posted June 14, 2023 Share Posted June 14, 2023 I have a stock of drapes with different widths (3m, 6m and 9m). I am creating a variety of 'rooms' using these drapes. Is there a way for VW to calculate the most efficient perimeter using this stock? For example, Room 1 needs a running length (with overlaps) of 46.6 meters. So I need 5 x 9m widths + 1 x 3m but current parameter settings indicate needing 6 x 9m widths, which is unnecessary . Cheers and Thank you, Jean-Yves Tessier VW2023 Quote Link to comment
Pat Stanford Posted June 15, 2023 Share Posted June 15, 2023 The formula will get a little convoluted, but it is relatively easy. Assuming you have the length in cell A6 of a worksheet, the following formulas will give you the number of 9', 6', 3' length for optimum coverage. B6. =ROUNDDOWN(A6/9, 0) C6. =ROUNDDOWN((A6-B6*9)/6, 0) D6. =ROUNDUP((A6-B6*9-C6*6)/3, 0) B6 gives you the number of full 9' segments. C6 Subtracts the length of 9' segments from the total length and uses that to see if a 6' segment will fit. D6 Subtracts the length of the 9' and 6' segments from the total lengths and calculates how many 3' segments will be required to fill the space. There are probably edge cases that will fail and you will get 2x 3' segments instead of a single 6' segment. Quote Link to comment
JYT Posted June 29, 2023 Author Share Posted June 29, 2023 Thank you, Pat. I was hoping there was a way to graphically represent this but the above is a great solution to figure out required inventory. Cheers! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.