Adding Your Own Parameters to the Status Table

K0013

Sort status tables by custom parameters like "Paint" or "Insulation"

Adding Spool Parameters to the Status Table The first 21 column headers in the status table, from Ctrl No. to Complete Date, are defined by the program and cannot be changed. Most of these columns are updated with information from the drawing each time a drawing is saved. The columns to the right of Complete Date have user-defined headers as in the example below.

‍

To edit the the user-defined headers, select Edit, Master Files, Fabrication Status.<cf>

You can have up to 60 user-defined column headers. If you choose to use any of the reserved headers listed in Table 1, those columns will be populated automatically and updated each time a drawing is saved.

For example, if you enter DIComplete as one of your custom headers, that column will automatically be populated with the number of diameter inches of weld on that spool for which a welderID has been entered. This value will be updated each time that spool is resaved. Reserved headers are not case-sensitive.

Table 1, List of Reserved Headers

Reserved Header	Description of Parameter
DICOMPLETE	The total diameter inch count for welds for which a welderID has been entered. Note that Dia-Inch is always present as column 9.
%COMPLETE	DICOMPLETE expressed as a percentage of Dia-Inch.
%INSP1, %INSP2 etc., up to %INSP5	The percentage of shop welds for which inspections have been completed. If the result is 100%, it shows the date the latest inspection was completed. See “Show-Inspection-Progress-in-Status-Table.pdf”.
FROM ISO	The percentage of shop welds for which inspections have been completed. If the result is 100%, it shows the date the latest inspection was completed. See “Show-Inspection-Progress-in-Status-Table.pdf”.
PRICE	The total price of materials, autolabor, and extra labor. (See PRICE and INVOICE on page 5.)
INVOICE	An invoice number, usually common to several spools.
FIT DATE	The earliest fit date entered for any weld in the spool.
WELD DATE	The earliest weld date entered for any weld in the spool.
FINAL WELD DATE	The latest weld date entered for any weld in the spool
FINAL FIT DATE	The latest fit date entered for any weld in the spool.
MAXNPS	The largest Nominal Pipe Size used on the spool. Items with zero quantity (e.g. an existing header) are ignored in determining MAXNPS.
LENGTHFT	The total length in feet of pipe and fittings having a sizeof MAXNPS. This is rounded to the nearest foot, except that any nonzero length less than one foot is rounded up to one foot.
TOTALFT	The total length in feet of all pipe and fittings regardlessof size, rounded up to the next foot. Excludes items with zero quantity.
VOLUMEFT3	The total volume capacity of all pipe and fittings regardless of size, expressed in cubic feet. Excludes items with zero quantity.
INTAREAFT2	The total internal surface area, expressed in square feet.
SHOP-DINCH	The total diameter-inch count for shop welds only. This is mainly useful on installation drawings, on which the regular diameter-inch count is for field welds only.
LINENO	The PIPELINE-REFERENCE parameter as read from a PCF file.
REVNAME	The revision number assigned by the user, can be up to five characters.
REVDESCR	The first 40 characters of the current revision description.
FABCODE	The fabrication code associated with the spec. Typical values are ASME B31.3, B31.1 etc.
BBOXM, BBOXFT	The bounding box that could contain the spool centerlines, e.g. 2.1x0.0x0.9

‍

Sample BBoxM and BBoxFT output:

‍

Another way you can arrange for a column to populate automatically is to set up an extra drawing item whose title is the same as the header. For example, in the example shown, if you have an extra drawing entry called “Fab Location”, the corresponding entry will appear in that column.

Usually columns with headers like “Fab.Comp. Date” or “PT Comp. Date” are not set up to be updated via Extra Drawing Information. Usually these columns are either updated manually by typing directly into the table, or they are updated using data from a bar code reader.

Displaying Parameters on the Drawing

This article focuses on taking data from the drawing and displaying it on the Status Table. To take data from the Status Table and display it on the drawing, see document K0032.

PRICE and INVOICE

The reserved headers PRICE and INVOICE are different from the others in that they do not update the status table each time the drawing is saved. They are only updated when batch mode is used. For example, if you are invoicing for spools 36, 38 and 78, you first select File, Make New List and select only those three drawings.

Then select File, Batch Operation, check the two boxes as shown, and enter the desired invoice number, shown here as 678.

When the batch runs, the prices of spools 36, 38 and 78 will be written to the PRICE column in the status table and the invoice number to the INVOICE column. At the same time, the pricing details are placed on the clipboard and are available for pasting to Excel.

‍

SpoolFab