Hi all,
I need to calculate how many pieces of MDF I can cut from a sheet at a certain size.
For example:
I need 206 meters at 350mm wide
The sheet size is 1220mm wide and 2000mts long
So I know on this occasion I can cut 3 pieces at 350mm wide at 2 meters long. This is obviously 6mts total
I would be left with some waste which I do not want included in my calculation
I am trying to create a sum that looks something like this, but I know this is not correct.
=ROUNDUP(SUM(250/((1220/350)*2)),0) This would return a sum of 36 Sheets but the quantity needed is actually 42
This is because the formula produces 3.48 as the answer from the (1220/350), but as I am calculating how many whole 350's I can get out of 1220 I need this to round down to 3.
As I have hundreds of different widths to calculate on a daily basis it would be great to have a formula set where I only have to change the width each time.
Any help would be greatly appreciated
Kind regards
Carl
I need to calculate how many pieces of MDF I can cut from a sheet at a certain size.
For example:
I need 206 meters at 350mm wide
The sheet size is 1220mm wide and 2000mts long
So I know on this occasion I can cut 3 pieces at 350mm wide at 2 meters long. This is obviously 6mts total
I would be left with some waste which I do not want included in my calculation
I am trying to create a sum that looks something like this, but I know this is not correct.
=ROUNDUP(SUM(250/((1220/350)*2)),0) This would return a sum of 36 Sheets but the quantity needed is actually 42
This is because the formula produces 3.48 as the answer from the (1220/350), but as I am calculating how many whole 350's I can get out of 1220 I need this to round down to 3.
As I have hundreds of different widths to calculate on a daily basis it would be great to have a formula set where I only have to change the width each time.
Any help would be greatly appreciated
Kind regards
Carl