Stock Drape Width Inventory

[JYT]

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

[Pat Stanford]

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.

[JYT]

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!