MATERIALLIST

Function:

Allows you to control whether the material list is shown on the isometric, and alter the display format if required.

Description:

The MATERIALLIST command allows you to control:

• Whether or not the list is shown on the drawing at all. The default is for the list to be plotted.

• The position of the list on the drawing sheet. The default is left-hand side.

• Whether the characters used for plotting the list are small, medium or large. The default is medium.

• The spacing between the lines in the list, relative to the default of 100.

• The order that columns of details are shown on the list, and whether columns are displayed at all.

• The width of the itemcode column in characters. Default is 8 characters and the maximum length is 29 characters. Both lengths exclude the leading / in the Marine name.

• Whether or not component descriptions are included in the list. By default all descriptions are included.

• Whether part numbers created in the SPOOLER module are used, or whether part numbers are generated automatically in Isodraft and held in the Design database (using the PARTNUMBERS FROMDB command), or part numbers generated by Isodraft (using the PARTNUMBERS GENERATED command).

• If you are using totalled database part numbers, multiple part numbers will be output, separated by spaces, in a single entry in the material list, wrapping round if the column width is exceeded. You should ensure that the part numbers column is wide enough to display several part numbers (say, eight characters) or the material list will be just as long. The quantity column will show the total of like items. Part number tags will still be individual.

• How the overflow of long lists is to be handled, and if extra sheets are needed, how they are to be numbered.

• Whether or not a weight column is added to the list, providing a summary tool for the fabrication and erection material along with an overall isometric material weight.

Formatting the Material List

If you leave Isodraft to its default settings (as described below), the material list will always be produced on the left hand side of the drawing sheet, using medium size characters to a standard linespacing. The itemcode column will be eight characters wide, and material descriptions will be included in the list. A separate material list will be plotted for every drawing sheet listing only the items on that sheet, with any continuations being plotted on a blank, dummy sheet.

These default settings will probably be appropriate for many uses of Isodraft. However, if need be you can change these settings to your own requirements. Examples of how to do this are included below.

For the total weight, a new text element is optionally placed below each material column.

A ‘--’ string is displayed when a weight cannot be found for the component.

The weight column and extra weight text is output to the MATLISTFILENAME file if selected.

Command Syntax:

Column c OTHER Heading ‘WEIGHT’ WEIGHT with WIDTH www [TOTAL FABRICATION] [TOTAL ERECTION] [TOTAL COMBINED] Factor f

Long Material Lists, and Sheet Numbering

If a material list is too long to fit onto one sheet it will normally be continued on a dummy sheet. This sheet will be identified DRG n OF m and will contain only the overflow of the material list. This is the default.

Alternatively, you can specify that the material list will be continued in a second area beside the first one. This will result in a non-standard size for the drawing sheet, which will exceed the normal width by the amount needed for the second material list.

Inclusion of Database Part Numbers

The SPOOLER module allows you to set part numbers on: piping components; sections of tubes; bolts and additional items. If this feature is used it applies to an individual pipe, individual branch or to a drawing as defined in the SPOOLER module.

The PARTNUMBERS FROMDB command allows you to include part numbers from the Design database in the material list. If Isodraft finds any unnumbered parts it will display an error message and halt the drawing of the isometric. You can specify SEParate part numbers, which will generate an entry for each item; TOTalled part numbers, which will create a single entry for each item with a quantity or PIPEonlyseparate, which will list all pipes separately but will generate a totalled list of other components.

If this part numbering feature of Design has not been used, Isodraft will produce part numbers according to its own system defaults.

If you are using the PARTNUMBERS FROMDB option you can define your own material list format. You can specify which items appear on the list, and in what order they appear. The TABLEDEFINITION command allows you to control the content, nature and order of standard column details in the material list. You can also define additional columns (using the commands TABLEDEFINITION COLUMNNUMBER text attribute). In this fashion you can define the additional column title, which SPCOM or component attribute or UDA will be used as data to fill the column, the column width and the order it will be shown on the list. A remarks column may be included for the cutting list remarks, since each piece of tube is listed separately.

Headings can optionally be specified as part of the TableDefinition Column syntax for standard columns by the following immediately after specifying the column contents, similarly to the previous syntax for non-standard columns.

Heading ‘NEW HEADING‘

Also similarly to the non-standard columns, NoHeading can be specified, resulting in a blank column title. This is achieved by adding the following immediately after specifying the column contents.

Heading NoHeading

Not specifying the heading will result in the alternative text for that column being used.

The PARTNUMBERS PERSPOOL command displays part numbers separately for each spool.

Note:
If the attribute of a chosen SPCOM is a reference UDA, referring to a text element, then the value of STEXT for that text appears in the column.

Examples:

Material list formatting

MATE OFF

Material list not shown on drawing.

MATE RIGHT CHARH 2.0

Material list plotted on right-hand side of drawing sheet, using 2.0mm high characters.

MATE LEFT CHARH 2.5

Material list plotted on left-hand side of drawing sheet, using 2.5mm high characters.

MATE LSPA 105

Increases the line spacing by 5%

MATE CODE 12

Itemcode column 12 characters wide.

MATE NODESC

Material descriptions omitted from list.

MATE DESC

Material descriptions included in list.

MATE GRIDlines ON

Show the horizontal and vertical lines on the Material List.

MATE GRIDlines OFF

Do not show the horizontal and vertical lines on the Material List.

MATE TABLED COL 1 QUANT

Defines column 1 in the material list as ‘Quantity’.

MATE TABLED COL 2 EMP

Sets column 2 as an empty column.

MATEriallist DRWG

Plots a separate material list on every drawing sheet, listing only items drawn on that sheet.

MATEriallist LINE

Plots, on the first drawing sheet, a single material list for the whole pipe line or system.

Long material lists

MATE DUMMY

Long list continued on separate drawing sheet, with no isometric plot on it. Single sheets not numbered. Multiple sheets numbered ‘1 of n’, ‘2 of n’ This is the default.

MATE DUMM SING

Long list continued on separate drawing sheet, which has no isometric plot on it. Single sheets numbered ‘1 of 1’. Multiple sheets numbered ‘1 of n’, ‘2 of n’

MATE DUMM SUFF

Long list continued on separate drawing sheet, which has no isometric plot on it. Single sheets not numbered. Multiple sheets numbered ‘1 of n’, ‘1A of n’ (for the sheet with the material list only), ‘2 of n’ etc

MATE OVER

Long list continued to the right of the preceding list on the same drawing sheet. Single sheets are not numbered.

Note:
This may produce non-standard drawing sizes.

MATE OVER SINGle

Long list continued to the right of the preceding list on the same drawing sheet. Sheets numbered ‘1 of n’, ‘2 of n’ Single sheets numbered ‘1 of 1’.

The default is:

MATE ON LEFT CHARH 2.45 LSPAC 100 CODE 8 DESC DUMMY DRWG

Related Commands:

ITEMCODE MTEXTS DTEXTS RESERVE

Command Syntax:

                  .---------------------------------<-----------------------------------.
/                                                                      |
 >-MATEriallist-*- ON* -.                                                               |
                |       |                                                               |
                |- OFF -+---------------------------------------------------------------|
                |                                                                       |
                |- LEFT* -.                                                             |
                |         |                                                             |
                |- RIGHT -+-------------------------------------------------------------|
                |                                                                       |
                |- CHARHeight - value --------------------------------------------------|
                |                                                                       |
                |- LSPAcing - integer --------------------------------------------------|
                |                                                                       |
                |- CODE - integer ------------------------------------------------------|
                |                                                                       |
                |- DESCriptions* -------------------------------------------------------|
                |                                                                       |
                |- NODEscriptions ------------------------------------------------------|
                |                                                                       |
                |- GRIDlines -+- ON* -.                                                 |
                |             |       |                                                 |
                |             ‘- OFF -+-------------------------------------------------|
                |                                                                       |
                |- TABLEdefinition -+---------------------------------------------------|
                |                   |                                                   |
                |                   ‘- COLumn val -+- PARTnumber --------------------.  |
                |                                  |                                 |  |
                |                                  |- DEScription -------------------|  |
                |                                  |                                 |  |
                |                                  |- BORe --------------------------|  |
                |                                  |                                 |  |
                |                                  |- ITEMcode ----------------------|  |
                |                                  |                                 |  |
                |                                  |- QUANtity -+- IN -+- <munits> --|  |
                |                                  |            |                    |  |
                |                                  |            ‘--------------------|  |
                |                                  |                                 |  |
                |                                  |- REMarks -+- AND -+- <remarks> -|  |
                |                                  |           |                     |  |
                |                                  |           ‘---------------------|  |
                |                                  |                                 |  |
                |                                  ‘- <other> -----------------------+--|
                |- PARTNumbers -+- PERSPool -.                                          |
                |               |            |                                          |
                |               ‘------------+-- FROMDB ---+-- SEParate ----------.     |
                |                            |             |                      |     |
                |                            |             |-- TOTalled ----------|     |
                |                            |             |                      |     |
                |                            |             ‘-- PIPEonlyseparate --+-----|
                |                            |                                          |
                |                            ‘ - GENerated -----------------------------|
                |- DUMMy* --.                                                           |
                |           |                                                           |
                |- OVER ----+-----------------------------------------------------------|
                |           |                                                           |
                |           |--- SUFFix ---+--------------------------------------------|
                |           |              |                                            |
                |           ‘--------------+--- SINGle ---------------------------------|
                |- DRWG* --.                                                            |
                |          |                                                            |
                ‘- LINE ---+------------------------------------------------------------+-->

where <munits> is

meters or MILlimeters.

This lets you set the metric units to be used for pipe lengths in the Quantity column.

Note:
That this affects metric isos only.

<remarks> is

    .------------------------------------------------------------------------.
   /                                                                         |
--*- attribute -+- FROMSPcom -.                      .-----------.           |
                |             |                     /            |           |
                ‘-------------+- ON -+- component -*             |           |
                                     |             |             |           |
                                     |- TUBE ------|             |           |
                                     |             |             |           |
                                     |- BOLT ------+- component -|           |
                                     |             |             |           |
                                     |             |- TUBE ------|           |
                                     |             |             |           |
                                     |             |- BOLT ------’           |
                                     |             |                         |
                                     ‘- ALL -------+- nl  -------------------|
                                                   |                         |
                                                   ‘-------------------------’

This allows attributes or UDAs to be taken from the catalogue or from the component, where component is one of the following:

BEND

ELBOw

CAP

CLOSure

COUPling

CROSs

FBLInd

FLANge

FTUBe

INSTrument

LJSEnd

OLET

TEE

PCOMPonent

REDUcer

SHU

TRAP

TUBE

UNIOn

VALVe

VFWAy

VTWAy

WELD

GASKet

SUPPort

ALL

<other> is -+- HEADing -.
            |           |
            |-----------+- text -.
            |                    |
            ‘- NOHeading --------+- attribute -+- FROMSPcom -|
                                 |             |             |
                                 |             ‘-------------|
                                 |
                                 ‘- WEIGHT -+- TOTAL FABRICATION -.
                                            |                     |
                                            ‘---------------------+--.
                                                                     |
      .-----------------------------<--------------------------------’
      |
      ‘--+- TOTAL ERECTION -.
         |                  |
         ‘------------------+- TOTAL COMBINED -.
                            |                  |
                            ‘------------------+- Factor --value --|
                                               |                   |
                                               ‘-------------------+--.
                                                                      |
      .-----------------------------<---------------------------------’
      |
      ‘--+- TubeFactor -- value --|
         |                        |
         ‘------------------------+-- WROUND OFF --.
                                  |                |
                                  +-- WROUND ON ---|
                                  |                |
                                  ‘----------------|

where WROUND ON indicates that, if a tube length is rounded-up, the corresponding tube weight is rounded-up accordingly.

Column width can be specified as part of the TABLEDEFINITION COLUMN syntax by adding:

- WITH WIdth value -+- nl -|
                    |      |
                    ‘------’

Querying:

Q MATEriallist

Q OPTions

Q MaterialList TableDefinition - will result in the headings being output in the expected format along with the rest of the column data.