hey market is bad u know geo. puteh also can do.
i am looking forward to see the answer.

Quote:

If it's a simple spreadsheet, you can just export it as an html file. If it's more complicated, you can only send it to me and I'll store it on the server and make a link for you.

Tim

Thanks Tim.

I'll give it another try by compressing the document ...


SOLUTION TO OPTIMIZATION THEORY


20 x 5.1m sawn into

LARGE SIZE
20 x 1.99m = 39.8m
20 x 1.33m = 26.6m

MEDIUM SIZE
08 x 1.755m = 14.04m
04 x 0.985m = 3.94m

SMALL SIZE
08 x 1.700m = 13.6m
04 x 0.765m = 3.06m

Wastage : 0.96m
---------------------------------------------------
08 x 5.1m sawn into

LARGE SIZE
16 x 2.035m = 32.56m

MEDIUM SIZE
08 x 0. 89m = 7.12m

SMALL SIZE
- nil -

Wastage : 1.12m
---------------------------------------------------
02 x 5.1 sawn into

LARGE SIZE
04 x 2.35m = 8.14m

MEDIUM SIZE
- nil -

SMALL SIZE
02 x 0.67m = 1.34m

Wastage : 0.72m
--------------------------------------------------
04 x 5.1m sawn into

LARGE SIZE
10 x 1.425m = 14.25m
- nil -

MEDIUM SIZE
- nil -
- nil -

SMALL SIZE
02 x 1.655m = 3.31m
02 x 0.670m = 1.34m


Wastage : 1.5m
---------------------------------------------------
07 x 5.1m sawn into

LARGE SIZE
- nil -
- nil -

MEDIUM SIZE
08 x 1.8m = 14.4m
- nil -

SMALL SIZE
06 x 1.655m = 9.93m
04 x 0.670m = 2.68m

Wastage : 8.69m
---------------------------------------------------
Summary:

41 x 5.1m = 209.10m
Large Size uses = 121.35m
Medium Size uses = 39.50m
Small Size uses = 35.26m
---------------------------------------------------
Total Usage = 196.11m
Wastage = 12.90m
---------------------------------------------------
% Wastage = 12.90/209.10x100
= 6.212339%
===================================================

Geoette's spreadsheet file can be found here.

Tim

Note: Link corrected.

Once again, thank you Tim.

However, my pc cannot display the link.

ps : many thanks Tim.

.... but how to get the answer?

Hi Lily

Two ways to get it.

One is by trial and error to derive at maximization of material usage.

Easy way out is to input data into an Optimization Software and receive instant results.

Architects, carpenters (according to Neo) and Quantity Surveyors, are people who are familiar with this type of calculations.

Quote:

Thank u, geo, the first method will never my choice,

Hello Lily

I would do the same as you. Time is of essence ...