Math/ Fomula Problem

Hi All,

This is a Math question as much as it is an Excel question (maybe a little more math) - So apologies if i have posted this in the wrong section.

I have a formula i use to work out how many Top Blanks I need to use to get an amount of Finished Tops for a job.
Top Blanks are always 3600 and i allow 10mm for saw cuts and machining.
Variables are Quantity (Qty) and the finished size of the top (Width)

=ROUNDUP(Qty/(ROUNDDOWN(3600/(Width+10),0)),0)

So what i need is a formula to include more than one finished size (Width2, Width3 etc) and a quantity for each width (Qty 2, Qty 3 etc)

Any Ideas will be appreciated!

Thanks, Adam

Thanks Bernie, I've never played with SUMPRODUCT so i will have a go at that today

Thanks shg - This spread sheet looks pretty good and i am keeping it, although its not quite what i'm looking for here. The problem i have is that the "ecxel" spreadsheets i use are a watered down version that are built into another program i use to run CNC machinery. They basically contain the data that generates all the machine code and material ordering reports/ shop drawings etc. The more i can make it do, the less i have to pull out the pocket calculator

Pl see attached file with formula with ans tallied.

Thanks kvsrinivasamurthy,

I have this part sorted although you've shown me a much simpler way to do it. Its just adding up the totals of each individual size. What i need it to do is get everything it can out of 3600.

IE - If i wanted 12 x900, i will need 4 x3600
- If i want 4 x800, i would need 1 x3600
- Yes if i add these up the total is 5
- BUT, If i want 12 x900 AND 4 x800 for the same job, i can get these out of the 4 x3600 by getting 3x900 and 1x800 out of each 3600.

And here in lies the mathematical problem!

shg,

The 10 is for saw cuts/ machining. That is why i only get 3 x 900 out of a 3600 - but i would get an 800 out of the offcut.