Adding Spool Parameters to the Status Table

K0013

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.