Hi,
I need some starter advice on a spreadsheet that can do the following (ill try keep it simple)

Pipes come in 3.0m lengths.

On Area 1 I use 0.7m pipe, 15 times.
On Area 2 I use 1.2m pipe, 7 times.
On Area 3 I use 0.65m pipe, 24 times.

What im trying to achieve is a spreadsheet that calculates how many 3.0m lengths of pipe i need, with the minimum amount of waste.

Can anyone start me off in the right direction.

Many thanks,

Lee