• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fitting plates on floor

P

Pulak

New Member
The Situation - I have to cover a floor whose dimensions can range from 8x8 to 20x100. I can order a set sizes of sheets which are: 4x8, 4x10, 4x12, 4x20 5x8, 5x10, 5x12, 5x20 6x8, 6x10, 6x12, 6x20 8x20, 8x40 10x20, 10x40 (40 ft sheets are not very preferable)

The Requirement - I want to have a formula which takes in the Length (L) and the Width (W) of the floor and reads the set of sheet sizes (L1, L2, L3..., W1, W2, W3...) given in a table and gives out the Sheet sizes and the number of them needed. The answer should be the least number of sheets used to cover the area. The area will always be square or rectangle. The goal is to utilize as few sheets as possible (with minimum wastage).

Example -
1) If I have a floor requirement of 12x20, I'll put in L=20 W=12. It should give me
Sheet size 6x20
No. 2
2) If the requirement is 13x50, it should give me:
Sheet Size 8x20
No. 2
Sheet size 5x20
No. 2
Sheet size 10x20
No. 1

I was trying to do something. Here is an attached excel file, if it helps
Thanks for all the help, people!! :) Let me know if you need more info.
 

Attachments

Yes I have seen that post. Its actually really clever. But what I am looking for is to cover the area with a set of plates. I don't have a specific size, I just want to use minimum no. of plates. So some plates can be aligned vertically and some horizontally, as per its need, like in example #2. Thanks. :)
 
Hi Pulak ,

Take a look at the uploaded file ; it is not a completed job , but WIP ; in case you think it might be useful , I can take it forward , but it will take some time.

The instructions are in the worksheet itself.

Narayan
 

Attachments

Narayan,

Wow, This is great, more than what I needed. :) But I am still not able to understand how this works. As you said this a WIP so I'll wait for you to finish. Thank you so much. I hope I can learn how to do this with your attached file.

Thank you.

Pulak
 
You must log in or register to reply here.
Back
Top