ISODRAFT Reference Manual
Command Reference Section : Alphabetical Command Reference : MATERIALLIST
MATERIALLIST
.
Function:
Allows the user to control whether the material list is shown on the isometric, and alter the display format if required.
Description:
The MATERIALLIST command allows the user 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 AVEVA E3D™ name.
•
Whether or not component descriptions are included in the list. By default all descriptions are included.
•
Whether part numbers created in the SPOOL 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 the user 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. The user should make sure 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 weight.
 
Formatting the Material List
If the user 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 the user can change these settings to their 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, the user 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 SPOOL module allows the user 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 SPOOL module.
 
The PARTNUMBERS FROMDB command allows the user 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. The user 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 MODEL has not been used, ISODRAFT will produce part numbers according to its own system defaults.
 
If the user are using the PARTNUMBERS FROMDB option the user can define their own material list format. The user can specify which items appear on the list, and in what order they appear. The TABLEDEFINITION command allows the user to control the content, nature and order of standard column details in the material list. The user can also define additional columns (using the commands TABLEDEFINITION COLUMNNUMBER text attribute). In this fashion the user 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.
 
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 TRUN/nionplatecategory FITT/ing
Trunnion Plates are to be shown under FITTINGS category on the Material List.
MATE TRUN/nionplatecategory SUPP/ort
Trunnion Plates are to be shown under SUPPORTS category 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’ etc. 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’ etc.
 
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’ etc. 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 ------------------------------------------------------|
                |c                        |
                |- GRIDlines -+- ON* -.                                                 |
                |             |       |                                                 |
                |             ‘- OFF -+-------------------------------------------------|
                |- TRUNnionplatecategory -+- FITTING* -.                                |
                | | | |
                |                         ‘- SUPPORT --+--------------------------------|
                |- 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
METres or MILlimetres.
This lets the user 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
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo