Quantity

The template pipe_mto.tmp outputs a report which shows the quantity of each type of item with a given Detail Text. Hence the important relationship is between Column 2, Detail Text, and Column 5, Quantity.

• Values are set to Sub for all the columns except Detail Text, where the 1st occurrence of each value is given.

• Subtotals is set to 2 for the Quantity column, which means that items with the same Detail Text are totalled.

The elements are first sorted alphabetically on type. The Material Text, and in the case of TUBI elements, the length, is also given.

The columns are set up as follows:

TYPE

Sort Aa to zZ, Precedence 1.

Values set to Sub, Subtotals Off and Total Off.

DTXR

Sort Aa to zZ, Precedence 2.

Values set to 1st, Subtotals Off and Total Off.

MTXX

No sorting.

Values set to Sub, Subtotals Off and Total Off.

ITLE

No sorting.

Values set to Sub, Subtotals set to 2 and Total Off.

QUANTITY

No sorting.

Values set to Sub, Subtotals set to 2 and Total Off.

Pipework MTO for /100-B-1 /100-B-2 /150-A-3

Type Detail Material Tube Quantity

Text Text

ATTA unset unset 5

ELBO ELBOW LR ANSI B16.9 BW ASTM A234-WPB 17

FLAN ANSI.B16.36.WN.ORIFACE.FLANGE.#300.RF ASTM A105 2

FLAN FLANGE WN ANSI B16.5 #150.RF ASTM A105 2

FLAN FLANGE WN ANSI B16.5 #300.RF ASTM A105 22

GASK GASKET RF 1.5MM ANSI B16.5 #150 SS & ASB 2

GASK GASKET RF 1.5MM ANSI B16.5 #300 SS & ASB 26

INST ORIFICE PLATE 3MM THK #300 unset 1

REDU NIPPLE CONC SWAGED BLE/PSE ASTM A234-WPB 2

REDU REDU CONC ANSI B16.9 BW ASTM A234-WPB 3

REDU REDU ECC ANSI B16.9 BW ASTM A234-WPB 2

TEE TEE ANSI B16.9 BW ASTM A234-WPB 5

TUBI PIPE SCH40 ANSI B36.10 API 5L-B 13410.56 51

VALV CTRL VALVE FISHER TYPE 657-ED #300.RF ASTM A216-WCB 2

VALV MISSION K WAFER CHECK VALVE #300 RF ASTM A216-WCB 2

VALV VALVE GATE ANSI B16.10 #150.RF ASTM A216-WCB 1

VALV VALVE GATE ANSI B16.10 #300.RF ASTM A216-WCB 5

VALV VALVE GLOBE ANSI B16.10 #300.RF ASTM A216-WCB 2