Formula for working out divided set lengths equally

[pricey74]

Hi Guys I am trying to get a spreadsheet that can do the following -

I build sheds for a living and I need a program that I can put in the width and height of the shed panels and the formula can work out how many lengths of cladding I need with minimal waste.

Now for the tricky bit the cladding comes in set lengths of 3.65m, 5.85m & 8m long and is 255mm wide boards.

Shed 1
So if the front & back panels are 2.7m wide x 2.0m high I will need 8 x 255mm boards in hieght to get to 2.0m high & the best combo would be 5.85m boards as we would get 2 @ 2.7m out of each 5.85m length with least waste.

So if the side panels are 2.0m wide x 2.0m high I will need 8 x 255mm boards in hieght to get to 2.0m high & the best combo would be 8m boards as we would get 4 @ 2.0m out of each 8m length with least waste.

Know it gets harder again.

Shed 2
I have a shed with front & back panels that are 2.1m wide & 2.0m high I still need 8 boards high.

If the side panels are 1.8m wide then I need the formula to work out what is the best set lengths for both panels as they have a combined length of 2.0m (front & back) & 1.8m (sides) total 3.8m lengths so 8m lengths will be least waste as we can get 2 @ 2m & 2 @ 1.8m with least waste.

Hope this all makes sense!!!

Is this possible to write a formula that could do all this for me?

Thanks Shayne