1DCutX - Excel linear cut optimizer / nesting software

Input Stocks Information

The dialog specifies the range of cells containing stock definitions.

Stock is a linear material, like tube, pipe, bar or wire that you need to cut by smaller pieces called Parts. The stocks are defined by their lengths, IDs, available quantities, diameters and material types. Only lengths are required, the rest are optional.

1DCutX reads the actual values of the stock data from the cells on Excel spreadsheets. You should specify these cells with stocks data on this page.

The numeric values can be specified in different formats (decimal, fractional or Imperial units). Click here to read more about supported formats.

Example.
The picture shows the stocks lengths are specified on Sheet1 in cells B7-B9. 1DCutX reads numeric values from these cells and uses them as input for the optimization.

ID of linear stocks

If you have unique text identification for each of the stock you can specify them in the first text box. You can leave that box empty and 1DCutX will assign sequential numbers as IDs (1, 2, 3, etc.).

Warning: It’s highly recommended to specify unique identification for each stock, otherwise you wouldn’t be able distinguish between stocks on the result reports.

Lengths

This is a mandatory range of cells containing list of stock lengths. All other stock ranges must have the same dimensions as this range.

For example, if you specified this range as B7-B9 then you defined 3 cells with stock lengths and other stock ranges must include 3 cells as well (the ID range could be A7-A9 or A2-C2).

Quantities

You can specify the number of available stocks of the appropriate length. If you don’t specify this range of cells then 1DCutX assumes there is unlimited quantity of stocks.

One of common scenario is to find out how many stock to order for the project. In this case you should leave this range empty and 1DCutX would calculate required number of stocks for each length.

Prices

This is an optional range that can help you calculate the total price of the materials for a project. Price is specified per one stock.

If you don’t need to calculate the costs then leave this range empty.

Diameters

If your project requires cutting of tubes with different diameters then you can use this range to specify diameters of your stocks. You also will need to specify the diameters of the parts on the Part Info page.

1DCutX will match the diameters of the stocks and parts during the optimization and it’ll make sure that parts with diameter 10 are cut from the stocks with diameter 10.

Material / Type

This is an optional range similar to the Diameters with differentiation by the stock materials or types. If you specified this range then you would need to specify the parts material/type on the Part Info page.

Example 1.
Your project needs steel and copper pipes, so you just specify material type as Steel or Copper for stocks and appropriate parts.

Example 2.
You cut steel profiles with different shapes (I-beam, T-shape, L-shape, etc.). In this case you should specify the shape as stock and part type and 1DCutX will match them during the optimization.