First time OpenSolver user

[AYouQueTai]

Hello,

I have 475 feet of pipe that I need to cut to the following sizes. Each pipe is 40 feet long (480 Inches) so I want to optimize the cuts in order to stay as close as possible to 12 pipes.
[TABLE="width: 96"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Inches[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD]8.00[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]10.00[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]12.00[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]27.00[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]32.00[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]41.50[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]89.75[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]94.00[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]105.00[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]111.00[/TD]
[TD]12
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 96"]
<colgroup><col><col></colgroup><tbody></tbody>[/TABLE]
my current spreadsheet has a table with 15 columns for possible cut sizes for 13 rows (pipes). J2:X14
I enter the different sizes manually in each row and try to keep the scrap pieces at the end at 5" or less. Then I move to the next one.

I've heard opensolver can do this automatically. I dont know how to feed it the data it needs, can anyone help?

Thanks